<?php

use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateJournalTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('journal', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name')->default('')->comment('期刊名称');
            $table->string('issn_eissn')->default('')->comment('ISSN/eISSN');
            $table->string('type')->default('')->comment('类别/学科');
            $table->string('jcr_abbreviation')->default('')->comment('JCR Abbreviation');
            $table->string('total_citations')->default('')->comment('Total Citations');
            $table->string('jif_2022')->default('')->comment('2022 JIF');
            $table->string('jif_quartile')->default('')->comment('JIF Quartile');
            $table->string('jci_2022')->default('')->comment('2022 JCI');
            $table->string('oa_gold')->default('')->comment('% of OA Gold');
            $table->string('sjr')->default('')->comment('SJR');
            $table->string('h_index')->default('')->comment('H-Index');
            $table->string('cite_score')->default('')->comment('CiteScore');
            $table->string('snip')->default('')->comment('SNIP');
            $table->string('public_cycle')->default('')->comment('出版周期');
            $table->string('type_label')->default('')->comment('分类标引');
            $table->string('open_access')->default('')->comment('开放获取');
            $table->string('public_difficult')->default('')->comment('发表难度');
            $table->string('publisher')->default('')->comment('出版商');
            $table->string('country_area')->default('')->comment('国家/出版地区');
            $table->dateTime('acceptance_time')->nullable()->comment('接受时间');
            $table->string('website')->default('')->comment('官网');
            $table->timestamps();
            $table->comment('期刊管理');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('journal');
    }
}
